query='''

DROP DATABASE IF EXISTS orchard;

CREATE DATABASE `orchard` /*!40100 DEFAULT CHARACTER SET latin1 */;

USE orchard;

CREATE TABLE `candidates` (
  `idcandidates` int(11) NOT NULL AUTO_INCREMENT,
  `reg_num` char(14) DEFAULT NULL,
  `pin` char(4) DEFAULT NULL,
  `name` char(90) DEFAULT NULL,
  `combination` int(11) DEFAULT NULL,
  `idScore` int(11) DEFAULT NULL,
  PRIMARY KEY (`idcandidates`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


CREATE TABLE `combinations` (
  `idcombination` int(11) NOT NULL AUTO_INCREMENT,
  `a` char(45) DEFAULT NULL,
  `b` char(45) DEFAULT NULL,
  `c` char(45) DEFAULT NULL,
  `d` char(45) DEFAULT NULL,
  PRIMARY KEY (`idcombination`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `scores` (
  `idscores` int(11) NOT NULL AUTO_INCREMENT,
  `a` int(11) DEFAULT NULL,
  `b` int(11) DEFAULT NULL,
  `c` int(11) DEFAULT NULL,
  `d` int(11) DEFAULT NULL,
  PRIMARY KEY (`idscores`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


CREATE TABLE `subjects` (
  `idsubject` int(11) NOT NULL AUTO_INCREMENT,
  `name` char(45) DEFAULT NULL,
  `short` char(3) DEFAULT NULL,
  PRIMARY KEY (`idsubject`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


'''